package cn.clwxy.gdz.dao;

import java.util.List;

import cn.clwxy.gdz.bo.TeacherInfoBean;
import cn.clwxy.gdz.entity.Student;
import cn.clwxy.gdz.entity.Teacher;

public interface TeacherDao {
	public List<Teacher> findTeacher();
	public List<Teacher> findTeacherByEducation(String education);
	public List<Teacher> findTeacherByAddress(String address);
	public List<Teacher> findTeacherBySex(String sex);
	public List<Teacher> findTeacherByLevel(Integer level);
	String findTeacherById(Integer id);
	
	Integer findImgIdByTeacherId(Integer teacherId);
	
	int changeHeadPic(Integer id,Integer imgId);
	int changeHeadPic(Integer id,String	src);
	
	int changeSex(Integer id,String sex);
	int changePwd(Teacher teacher);
	int changeWorkType(Integer id,String workType);
	int changeTeacherType(Integer id,Integer teacherType);
	int changeEducation(Integer id,String education);
	int changeWorkYeas(Integer id,String workYears);
	TeacherInfoBean findTeacherGradesById(Integer teacherId);
	TeacherInfoBean findTeacherAddressIdById(Integer teacherId);
	int changeName(Integer teacherId,String teacherName);
	/**
	 * 
	 * @param subject ��Ŀ
	 * @param grade �꼶
	 * @param area����
	 * @param sex�Ա�
	 * @param teacherage ��ѧ����
	 * @param education ����
	 * @param type  ���� ����˵�����ݽ�ʦ
	 * @param pageNo ��ǰҳ
	 * @return
	 */
	public List<Teacher> querTeacherList(String subject, String grade,
			String area, String sex, Integer startYear,Integer endYear, String education,
			String type,String workTyepe, Integer pageNo);
	/**
	 * ������ķ���������ͬ���ǲ�ѯ������
	 * @param subject
	 * @param grade
	 * @param area
	 * @param sex
	 * @param teacherage
	 * @param education
	 * @param type
	 * @param pageNo
	 * @return
	 */
	public Long queryCount(String subject, String grade, String area,String sex, Integer startYear,Integer endYear, String education, String type,String workType);
	/**
	 * 2017-11-11 ����
	 * ��ѯ����,���ҳ
	 */
	public List<Teacher> queryTeacherList(Integer pageNo);
	/**
	 * ��������
	 * @return
	 */
	public Long queryCount();
	/**
	 * ɾ����ʦ
	 * @param id
	 * @return
	 */
	public int deletTeacher(Integer id);
	/**
	 * �޸�ѧ��ȼ�
	 * @param level
	 * @return
	 */
	public int changeLevel(int id,int level);
}